﻿<?php
	include('pub.php'); 
	include(_ROOT.'/db.php');
	include(_ROOT.'/title.php');
?>
<form action="showPapers.php" method="post">
	<table width="768" align="center">
		<tr>
			<td>
				年月: 
				<select name="year">
					<?php 
						$sql = "select t_year from t_year order by t_year desc";
						$data = mysql_query($sql, $conn);
						while ($arr = mysql_fetch_array($data))
						{
					?>
					<?php
							echo '<option value='.$arr[t_year].'>'.$arr[t_year].'</option>';
						}
					?>
				</select>
			</td>
		</tr>
		<tr>
			<td>
				等级: 
				<select name="level">
					<?php 
						$sql = "select * from t_level";
						$data = mysql_query($sql, $conn);
						while ($arr = mysql_fetch_array($data))
						{
					?>
					<?php
							echo '<option value='.$arr[t_level].'>'.$arr[t_level].'</option>';
						}
					?>
				</select>
			</td>
		</tr>
		<tr>
			<td>
				题型: 
				<select name="class">
					<?php 
						$sql = "select * from t_class";
						$data = mysql_query($sql, $conn);
						while ($arr = mysql_fetch_array($data))
						{
					?>
					<?php
							echo '<option value='.$arr[t_class].'>'.$arr[t_class].'</option>';
						}
					?>
				</select>
			</td>
		</tr>
	</table>
	<table width="768" align="center">
		<tr>
			<td>
				<input type="submit" value="submit"></input>
			</td>
		</tr>
	</table>
</form>
<?php
	include (_ROOT.'/bottom.php');
?>